{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["1 неделя","2 неделя","Лист2"],"read":"whole","date_system":"1900"}

{"sheet":"1 неделя","index":0,"n_rows":153,"n_cols":4,"rows_kept":153}
["1 неделя","Выход, гр","Цена, 1 кг","Цена в блюде"]
["Понедельник"]
["Фрукты свежие",100]
["Апельсин",100,150,{"$f":"C4/1000*B4","v":15}]
["Салат из моркови с сахаром",60]
["Сахар",3,80,{"$f":"C6/1000*B6","v":0.24}]
["Морковь",72,35,{"$f":"C7/1000*B7","v":2.5200000000000005}]
["Бифштекс рубленный",80]
["Говядина (котлетное мясо)",105,440,46.2]
["Молоко",5,65,0.325]
["Соль",1,16,0.016]
["Масло растительное",5,140,0.7000000000000001]
["Каша вязска гречневая",150]
["Гречка",71,100,7.1000000000000005]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Чай с молоком","150/50/15"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Молоко",51,65,3.315]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость понедельник",null,null,{"$f":"SUM(D4:D22)","v":83.26500000000001}]
["Вторник"]
["Фркты",100]
["Груша",100,280,{"$f":"C26/1000*B26","v":28.000000000000004}]
["Салат из белокочанной капусты",60]
["Капуста",59,25,{"$f":"C28/1000*B28","v":1.475}]
["Морковь",6,35,{"$f":"C29/1000*B29","v":0.21000000000000002}]
["Сахар",3,80,0.24]
["Масло растительное",3,140,0.42000000000000004]
["Рагу из птицы",200]
["Грудка куриная",104,270,28.080000000000002]
["Масло ратистельное",2,140,0.28]
["Картофель",128,25,3.2]
["Морковь",25,35,0.8750000000000001]
["Томат паста",7,175,1.2249999999999999]
["Лук репчатый",14,30,0.42]
["Масло растительное",5,140,0.7000000000000001]
["Мука пшеничная",1,40,0.04]
["Соль",1,16,0.016]
["Какао с молоком",200]
["Какао-порошок",4,271,1.084]
["Молоко",100,65,6.5]
["Сахар",20,80,1.6]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость вторник",null,null,{"$f":"SUM(D26:D47)","v":77.18500000000002}]
["Среда"]
["Фрукты свежие",100]
["Яблоко",100,100,{"$f":"C51/1000*B51","v":10}]
["Салат из зеленого горошка",55]
["Зеленый горошек",100,75,{"$f":"C53/1000*B53","v":7.5}]
["Лук репчатый",5,30,{"$f":"C54/1000*B54","v":0.15}]
["Масло растительное",2,140,{"$f":"C55/1000*B55","v":0.28}]
["Мясо тушеное","50/50"]
["Говядина (котлетное мясо)",83,440,36.52]
["Морковь",5,35,0.17500000000000002]
["Лук репчатый",5,30,0.15]
["Масло растительное",5,140,0.7000000000000001]
["Томат паста",7,175,1.2249999999999999]
["Мука пшеничная",2,40,0.08]
["Соль",1,16,0.016]
["Макаронные изделия отварные с маслом","150/5"]
["Макаронные изделия",53,50,2.6500000000000004]
["Масло сливочное",5,550,2.75]
["Соль",2,16,0.032]
["Чай с лимоном","200/15/7"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Лимон",8,170,1.36]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость среда",null,null,{"$f":"SUM(D51:D73)","v":68.29599999999999}]
["Четверг"]
["Салат овощной с яблоками",60]
["Свекла",13,20,{"$f":"C77/1000*B77","v":0.26}]
["Морковь",10,35,{"$f":"C78/1000*B78","v":0.35000000000000003}]
["Капуста белокочанная",23,25,0.5750000000000001]
["Яблоки",28,100,2.8000000000000003]
["Лимон (для сока)",12,170,2.04]
["Котлеты рубленные из бройлер-цыплят",80]
["Грудка куриная",136,270,36.72]
["Хлеб пшеничный",13,60,0.78]
["Молоко",19,62,1.178]
["Сухари",5,100,0.5]
["Масло ратистельное",3,140,0.42000000000000004]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Пюре картофельное",150]
["Картофель",197,25,4.925000000000001]
["Молоко",24,62,1.488]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Чай с сахаром","200/15"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость четверг",null,null,{"$f":"SUM(D77:D99)","v":63.025999999999996}]
["Пятница"]
["Свежие фрукты",100]
["Апельсин",100,150,{"$f":"C103/1000*B103","v":15}]
["Салат из моркови с яблоками",60]
["Морковь",57,35,{"$f":"C105/1000*B105","v":1.995}]
["Яблоки свежие",22,100,{"$f":"C106/1000*B106","v":2.2}]
["Сахар",1,80,0.08]
["Котлеты ",80]
["Говядина (котлетное мясо)",60,440,26.4]
["Хлеб пшенинчый ",9,60,0.54]
["Молоко",12,62,0.744]
["Сухари",5,100,0.5]
["Масло растительное",3,140,0.42000000000000004]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Рис отварной",150]
["Рис",55,90,4.95]
["Масло сливочное",7,625,4.375]
["Соль",1,16,0.016]
["Чай с молоком","150/50/15"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Молоко",51,65,3.315]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость пятница",null,null,{"$f":"SUM(D103:D125)","v":68.384}]
["Суббота"]
["Плоды и ягода свежие (яблоки)",100]
["Яблоки",100,100,{"$f":"C129/1000*B129","v":10}]
["Салат из квашеной капусты",60]
["Капуста квашеная",70,180,{"$f":"C131/1000*B131","v":12.6}]
["Лук репчатый",7,30,0.21]
["Сахар",3,80,0.24]
["Масло растительное",3,140,0.42000000000000004]
["Говядина тушеная","60/30"]
["Говядина",83,440,{"$f":"C136/1000*B136","v":36.52}]
["Морковь свежая",5,35,0.17500000000000002]
["Лук",5,30,0.15]
["Масло растительное",5,140,0.7000000000000001]
["Томатная паста",7,175,1.2249999999999999]
["Мука пшеничная",2,40,0.08]
["Соль",1,16,0.016]
["Макаронные изделия отварные ",150]
["Макаронные изделия",53,50,{"$f":"C144/1000*B144","v":2.6500000000000004}]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Кофейный напиток с молоком",200]
["Кофейный напиток",5,500,2.5]
["Сахар",20,80,1.6]
["Молоко",100,65,6.5]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость суббота",null,null,{"$f":"SUM(D129:D152)","v":81.547}]

{"sheet":"2 неделя","index":1,"n_rows":146,"n_cols":7,"rows_kept":146}
["2 неделя","Выход, гр","Цена, 1 кг","Цена в блюде"]
["Понедельник"]
["Фрукты свежие",100]
["Апельсин",100,150,{"$f":"C4/1000*B4","v":15}]
["Салат из белокочанной капусты",60]
["Капуста",59,25,{"$f":"C6/1000*B6","v":1.475}]
["Морковь",6,35,0.21000000000000002]
["Сахар",3,80,0.24]
["Масло растительное",3,140,0.42000000000000004]
["Фрикадельки в соусе","55/50"]
["Говядина (котлетное мясо)",38,440,16.72]
["Хлеб пшеничный",8,60,0.48]
["Молоко",11,65,0.7150000000000001]
["Лук репчатый",5,30,0.15]
["Мука пшеничная",5,40,0.2]
["Масло растительное ",5,140,0.7000000000000001]
["Сметана",12.5,190,2.375]
["Мука пшеничная",4,40,0.16]
["Соль",1,16,0.016]
["Каша рассыпчатая (гречневая)",150]
["Гречка",71,100,7.1000000000000005]
["Соль",1,16,0.016]
["Чай с сахаром","200/15"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость понедельник",null,null,{"$f":"SUM(D4:D27)","v":50.685}]
["Вторник"]
["Сок натуральный",150]
["Сок натуральный",150,80,{"$f":"C31/1000*B31","v":12}]
["Салат из свеклы отварной",60]
["Свекла",73,20,{"$f":"C33/1000*B33","v":1.46}]
["Масло растительное",3,140,{"$f":"C34/1000*B34","v":0.42000000000000004}]
["Плов из птицы","50/150"]
["Грудка куриная",96,270,25.92]
["Масло растительное",7,140,0.9800000000000001]
["Лук репчатый",8,30,0.24]
["Морковь",15,35,0.525]
["Томат паста",7,175,1.2249999999999999]
["Рис",52,90,4.68]
["Соль",1,16,0.016]
["Чай с лимоном","200/15/7"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Лимон",8,170,1.36]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость вторник",null,null,{"$f":"SUM(D31:D48)","v":53.534000000000006}]
["Среда"]
["Салат из квашеной капусты",60]
["Капуста квашеная",70,180,{"$f":"C52/1000*B52","v":12.6}]
["Лук репчатый",7,30,{"$f":"C53/1000*B53","v":0.21}]
["Сахар",3,80,0.24]
["Масло растительное",3,140,0.42000000000000004]
["Биточки рыбные",80]
["Филе минтая",112,325,36.4]
["Яйцо 1 кат., шт",0.2,0,0]
["Сухари панировочные",7,0,0]
["Молоко ",13,0,0]
["Лук репчатый очищенный",3,0,0]
["Соль",1,0,0]
["Масло растительное  ",2,0,0]
["Пюре картофельное",150]
["Картофель",197,25,4.925000000000001]
["Молоко",24,65,1.56]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Кофейный напиток с молоком",200]
["Кофейный напиток",5,500,2.5]
["Сахар",20,80,1.6]
["Молоко",100,65,6.5]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость среда",null,null,{"$f":"SUM(D52:D74)","v":72.916}]
["Четверг"]
["Фрукты свежие",100]
["Апельсин",100,150,{"$f":"C78/1000*B78","v":15}]
["Салат из моркови с сахаром",60]
["Сахар",3,80,{"$f":"C80/1000*B80","v":0.24}]
["Морковь",72,35,{"$f":"C81/1000*B81","v":2.5200000000000005}]
["Котлеты рубленные из птицы",90]
["Грудка куриная",77,270,{"$f":"C83/1000*B83","v":20.790000000000003}]
["Хлеб пшеничный",14,60,0.84]
["Молоко",19,65,1.235]
["Сухари панировочные",8,100,0.8]
["Масло растительное",5,140,0.7000000000000001]
["Масло сливочное",2,625,1.25]
["Соль",1,16,0.016]
["Макаронные изделия отварные с маслом","150/5"]
["Макаронные изделия",53,50,2.6500000000000004]
["Масло сливочное",5,625,3.125]
["Соль",1,16,0.016]
["Какао с молоком",200]
["Какао-порошок",4,271,1.084]
["Молоко",100,65,6.5]
["Сахар",20,80,1.6]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость четверг",null,null,{"$f":"SUM(D78:D99)","v":61.18600000000001}]
["Пятница"]
["Фрукты свежие",100]
["Груша",100,280,{"$f":"C103/1000*B103","v":28.000000000000004}]
["Салат из свеклы отварной",60]
["Свекла",73,20,{"$f":"C105/1000*B105","v":1.46}]
["Масло растительное",3,140,{"$f":"C106/1000*B106","v":0.42000000000000004}]
["Птица тушеная в соусе","50/50"]
["Грудка куриная",99,270,26.73]
["Масло растительное",2,140,0.28]
["Сметана",12.5,190,2.375]
["Мука пшеничная",4,40,0.16]
["Соль",1,16,0.016]
["Рис отварной",150]
["Рис",55,90,4.95]
["Масло сливочное",7,625,4.375]
["Чай с сахаром","200/15"]
["Чай",1,688,0.688]
["Сахар",15,80,1.2]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость пятница",null,null,{"$f":"SUM(D103:D120)","v":73.474}]
["Суббота"]
["Плоды и ягода свежие (яблоки)",100]
["Яблоки",100,100,{"$f":"C124/1000*B124","v":10}]
["Салат овощной с яблоками",60]
["Свекла",13,20,{"$f":"C126/1000*B126","v":0.26}]
["Морковь",10,35,0.35000000000000003]
["Капуста белокочанная",23,25,0.5750000000000001]
["Яблоки",28,100,2.8000000000000003]
["Лимон (для сока)",12,170,2.04]
["Плов из птицы","50/150"]
["Грудка куриная",96,270,{"$f":"C132/1000*B132","v":25.92}]
["Масло растительное",7,140,0.9800000000000001]
["Лук репчатый",8,30,0.24]
["Морковь",15,35,0.525]
["Томат паста",7,175,1.2249999999999999]
["Рис",52,90,4.68]
["Соль",1,16,0.016]
["Какао с молоком",200]
["Какао-порошок",4,271,{"$f":"C140/1000*B140","v":1.084}]
["Молоко",100,65,6.5]
["Сахар",20,80,1.6]
["Хлеб пшеничный",30,60,1.7999999999999998]
["Хлеб ржано-пшеничный",20,51,1.02]
["Стоимость суббота",null,null,{"$f":"SUM(D124:D144)","v":61.615}]
["Итого за 2 недели",null,null,{"$f":"'1 неделя'!D23+'1 неделя'!D48+'1 неделя'!D74+'1 неделя'!D100+'1 неделя'!D126+'1 неделя'!D153+'2 неделя'!D28+'2 неделя'!D49+'2 неделя'!D75+'2 неделя'!D100+'2 неделя'!D121+'2 неделя'!D145","v":815.1130000000003},null,801.12,"контрольная цифра за 2 недели при стоимости 66,76 за 1 детодень "]

{"sheet":"Лист2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}